De Zeemeerman

De Zeemeerman is a 1996 Dutch comedy film directed by Frank Herrebout. The movie revolves around a young man who has a hard time getting girls because he permanently smells of fish. The cure, offered by a mad professor, turns him into a male mermaid, or merman zeemeerman in Dutch.

Source: Wikipedia